clear
*cd "add_path\replication\data"

********************************************************************************
*** Load and Setup Data ***

* Load FOMC-Bloomberg panel
use "./data/fomc_panel_news"

* Standardize News shocks
egen emp_std = sd(emp)
gen emp1 = emp/emp_std

egen gdp_std = sd(gdp)
gen gdp1 = gdp/gdp_std

egen ret_std = sd(ret)
gen ret1 = ret/ret_std

egen cpi_std = sd(cpi)
gen cpi1 = cpi/cpi_std

egen ppi_std = sd(ppi)
gen ppi1 = ppi/ppi_std

drop emp gdp ret cpi ppi 
rename emp1 emp 
rename gdp1 gdp  
rename ret1 ret  
rename cpi1 cpi  
rename ppi1 ppi

* Multiply FX & Stocks by 100
replace fx_2day = fx_2day*100
replace stk_2day = stk_2day*100

* Standardize Asset Changes
rename fx_2day fx_unscl
rename stk_2day stk_unscl
rename yield3m_2day yield3m_unscl
rename yield2y_2day yield2y_unscl
rename yield5y_2day yield5y_unscl
rename yield10y_2day yield10y_unscl
rename exp2y_2day exp2y_unscl
rename exp10y_2day exp10y_unscl
rename tp2y_2day tp2y_unscl
rename tp10y_2day tp10y_unscl

sort ccode 
by ccode: egen fx_std = sd(fx_unscl)
by ccode: egen stk_std = sd(stk_unscl)
by ccode: egen yield3m_std = sd(yield3m_unscl)
by ccode: egen yield2y_std = sd(yield2y_unscl)
by ccode: egen yield5y_std = sd(yield5y_unscl)
by ccode: egen yield10y_std = sd(yield10y_unscl)
by ccode: egen exp2y_std = sd(exp2y_unscl)
by ccode: egen exp10y_std = sd(exp10y_unscl)
by ccode: egen tp2y_std = sd(tp2y_unscl)
by ccode: egen tp10y_std = sd(tp10y_unscl)

sort ccode date
gen fx_2day = fx_unscl/fx_std
gen stk_2day = stk_unscl/stk_std
gen yield3m_2day = yield3m_unscl/yield3m_std
gen yield2y_2day = yield2y_unscl/yield2y_std
gen yield5y_2day = yield5y_unscl/yield5y_std
gen yield10y_2day = yield10y_unscl/yield10y_std
gen exp2y_2day = exp2y_unscl/exp2y_std
gen exp10y_2day = exp10y_unscl/exp10y_std
gen tp2y_2day = tp2y_unscl/tp2y_std
gen tp10y_2day = tp10y_unscl/tp10y_std


* Label Variables
label var fx_1day "Exchange Rate"
label var fx_2day "Exchange Rate"
label var stk_1day "Stock Return"
label var stk_2day "Stock Return"
label var yield3m_1day "3 Month Yield"
label var yield3m_2day "3 Month Yield"
label var yield2y_1day "2 Year Yield"
label var yield2y_2day "2 Year Yield"
label var yield5y_1day "5 Year Yield"
label var yield5y_2day "5 Year Yield"
label var yield10y_1day "10 Year Yield"
label var yield10y_2day "10 Year Yield"

label var tp2y_1day "2 Year Term Prm"
label var tp2y_2day "2 Year Term Prm"
label var tp10y_1day "10 Year Term Prm"
label var tp10y_2day "10 Year Term Prm"
label var exp2y_1day "2 Year Exp Comp"
label var exp2y_2day "2 Year Exp Comp"
label var exp10y_1day "10 Year Exp Comp"
label var exp10y_2day "10 Year Exp Comp"


* Drop Venezuela, US, Brazil, Mexico, Taiwan, Greece
keep if ccode < 49 
drop if ccode == 5 | ccode == 28 | ccode == 45 | ccode == 15 


* Drop dates - no FOMC announcement / coordinated action
drop if date == td(22may2013)
drop if date == td(08oct2008)


* Start sample in 1995
keep if date >= td(01jan1995)

* Fill missing news dates with 0s
replace emp = 0 if emp == .
replace gdp = 0 if gdp == .
replace ret = 0 if ret == .
replace cpi = 0 if cpi == .
replace ppi = 0 if ppi == .

*cd "add_path\replication"

********************************************************************************
* MP
reghdfe yield2y_2day mps_2day mpu_2day if advanced == 1 & fomc_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_a.xml", replace se bdec(3) bracket label
reghdfe yield10y_2day mps_2day mpu_2day if advanced == 1 & fomc_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_a.xml", append se bdec(3) bracket label
reghdfe yield2y_2day mps_2day mpu_2day if advanced == 0 & fomc_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_a.xml", append se bdec(3) bracket label
reghdfe yield10y_2day mps_2day mpu_2day if advanced == 0 & fomc_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_a.xml", append se bdec(3) bracket label

*Emp
reghdfe yield2y_2day emp if advanced == 1 & emp_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_b.xml", replace se bdec(3) bracket label
reghdfe yield10y_2day emp if advanced == 1 & emp_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_b.xml", append se bdec(3) bracket label
reghdfe yield2y_2day emp if advanced == 0 & emp_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_b.xml", append se bdec(3) bracket label
reghdfe yield10y_2day emp if advanced == 0 & emp_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_b.xml", append se bdec(3) bracket label

*GDP
reghdfe yield2y_2day gdp if advanced == 1 & gdp_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_c.xml", replace se bdec(3) bracket label
reghdfe yield10y_2day gdp if advanced == 1 & gdp_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_c.xml", append se bdec(3) bracket label
reghdfe yield2y_2day gdp if advanced == 0 & gdp_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_c.xml", append se bdec(3) bracket label
reghdfe yield10y_2day gdp if advanced == 0 & gdp_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_c.xml", append se bdec(3) bracket label

*Sales
reghdfe yield2y_2day ret if advanced == 1 & ret_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_d.xml", replace se bdec(3) bracket label
reghdfe yield10y_2day ret if advanced == 1 & ret_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_d.xml", append se bdec(3) bracket label
reghdfe yield2y_2day ret if advanced == 0 & ret_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_d.xml", append se bdec(3) bracket label
reghdfe yield10y_2day ret if advanced == 0 & ret_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_d.xml", append se bdec(3) bracket label

*CPI
reghdfe yield2y_2day cpi if advanced == 1 & cpi_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_e.xml", replace se bdec(3) bracket label
reghdfe yield10y_2day cpi if advanced == 1 & cpi_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_e.xml", append se bdec(3) bracket label
reghdfe yield2y_2day cpi if advanced == 0 & cpi_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_e.xml", append se bdec(3) bracket label
reghdfe yield10y_2day cpi if advanced == 0 & cpi_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_e.xml", append se bdec(3) bracket label

*PPI
reghdfe yield2y_2day ppi if advanced == 1 & ppi_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_f.xml", replace se bdec(3) bracket label
reghdfe yield10y_2day ppi if advanced == 1 & ppi_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_f.xml", append se bdec(3) bracket label
reghdfe yield2y_2day ppi if advanced == 0 & ppi_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_f.xml", append se bdec(3) bracket label
reghdfe yield10y_2day ppi if advanced == 0 & ppi_day==1, noabsorb cluster(ccode time)
outreg2 using "tables\table4_f.xml", append se bdec(3) bracket label

********************************************************************************
